how do you bind datagridview with chart?

Ho Hui Jun 2763 29-Dec-2015

hi there, I really need help on this project that I am dealing with. It is to calculate free surface effect of a vessel on large angle which I have no idea where it when wrong.

how do you bind datagridview with chart?

it doesn't show any chart on the right side.

below is the code for the chart. I do appreciate if anyone could help me with this.

Private Sub GZChart_Click(sender As Object, e As EventArgs) Handles GZChart.Click
        GZChart.ChartAreas.Add("area")
        GZChart.ChartAreas("area").AxisX.Minimum = 0
        GZChart.ChartAreas("area").AxisY.Minimum = 0
        GZChart.ChartAreas("area").AxisX.Maximum = 100
        GZChart.ChartAreas("area").AxisY.Maximum = 20
        GZChart.ChartAreas("area").AxisX.Interval = 10
        GZChart.ChartAreas("area").AxisX.Interval = 0.5
        GZChart.Series("Series1").Color = Color.Red
        GZChart.Series("Series1").ChartType = DataVisualization.Charting.SeriesChartType.SplineArea
        GZChart.Series.Clear()
        GZChart.Series.Add("Series1")
        GZChart.Series("Series1").Points.Clear()
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(0).Cells(1).Value, DataGridView.Rows(0).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(1).Cells(1).Value, DataGridView.Rows(1).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(2).Cells(1).Value, DataGridView.Rows(2).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(3).Cells(1).Value, DataGridView.Rows(3).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(4).Cells(1).Value, DataGridView.Rows(4).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(5).Cells(1).Value, DataGridView.Rows(5).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(6).Cells(1).Value, DataGridView.Rows(6).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(7).Cells(1).Value, DataGridView.Rows(7).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(8).Cells(1).Value, DataGridView.Rows(8).Cells(3).Value)
        GZChart.Series("Series1").Points.AddXY(DataGridView.Columns(3).HeaderText & "--", DataGridView.Rows(9).Cells(1).Value, DataGridView.Rows(9).Cells(3).Value)
    End Sub

chart datagridview

Updated on 08-Jan-2016

public class Product
{
public string ProductName { get; set; }
public int Qty { get; set; }
public float Price { get; set; }
}

List<Product> list = new List<Product>();
list.Add(new Product { ProductName = "Pendrive", Qty = 10, Price = 323 });
list.Add(new Product { ProductName = "Laptop", Qty = 23, Price = 1445 });
list.Add(new Product { ProductName = "Computer", Qty = 34, Price = 1446 });
DGV1.DataSource = list;

chart1.Series.Clear();
chart1.Series.Add("Pendrive");
chart1.Series.Add("Laptop");
chart1.Series.Add("Computer");
chart1.Series["Pendrive"].Points.Clear();
chart1.Series["Pendrive"].Points.AddXY("Product", DGV1.Rows[0].Cells[1].Value);
chart1.Series["Laptop"].Points.Clear();
chart1.Series["Laptop"].Points.AddXY("Product", DGV1.Rows[1].Cells[1].Value);
chart1.Series["Computer"].Points.Clear();
chart1.Series["Computer"].Points.AddXY("Product", DGV1.Rows[2].Cells[1].Value);

Can you answer this question?

Answer